Apple Reference & Presen…tion Library 1994 January/ARPL-Jan94-Disc2of2-Partner-Edition.iso/Applications/Databases/GQL V3.1 Demo Folder/USA Sales Information/USA Sales Information.rsrc/gDEM_10422_Eastern Sales by City

Text File | 1993-07-07 | 253 b | 1 lines

select customer.cust_city, AVG (orders.ord_amount) from customer, orders where ((customer.cust_state IN ('MI','IN','PA','NY','NH','ME','KY','MA','TN','NC','SC','GA','FL'))) and customer.cust_num = orders.cust_nr group by customer.cust_city order by 1 ;